DELIMITER $$

DROP PROCEDURE IF EXISTS `tbtx_crm`.`test`$$

CREATE DEFINER=`root`@`%` PROCEDURE `test`(IN inpare varchar(50),OUT outpare1 int)
BEGIN
	#
	select * from sys_user;
	select count(*)into outpare1 from sys_user;
	select * from sys_role;
	#select * from sys_user;
		
	
    END$$

DELIMITER ;